﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE TRIGGER dbo.User_UpdateDate_trg ON dbo.[User]
    AFTER UPDATE
AS
    BEGIN
        UPDATE  dbo.[USER]
        SET     UpdateDate = GETDATE()
        FROM    dbo.[USER]
        INNER JOIN INSERTED ON [USER].ID = INSERTED.ID

    END